package com.jd.risk.bankorder.entity.bankorder;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TeslaBankRequestExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    public TeslaBankRequestExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andRequestNoIsNull() {
            addCriterion("request_no is null");
            return (Criteria) this;
        }

        public Criteria andRequestNoIsNotNull() {
            addCriterion("request_no is not null");
            return (Criteria) this;
        }

        public Criteria andRequestNoEqualTo(String value) {
            addCriterion("request_no =", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoNotEqualTo(String value) {
            addCriterion("request_no <>", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoGreaterThan(String value) {
            addCriterion("request_no >", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoGreaterThanOrEqualTo(String value) {
            addCriterion("request_no >=", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoLessThan(String value) {
            addCriterion("request_no <", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoLessThanOrEqualTo(String value) {
            addCriterion("request_no <=", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoLike(String value) {
            addCriterion("request_no like", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoNotLike(String value) {
            addCriterion("request_no not like", value, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoIn(List<String> values) {
            addCriterion("request_no in", values, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoNotIn(List<String> values) {
            addCriterion("request_no not in", values, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoBetween(String value1, String value2) {
            addCriterion("request_no between", value1, value2, "requestNo");
            return (Criteria) this;
        }

        public Criteria andRequestNoNotBetween(String value1, String value2) {
            addCriterion("request_no not between", value1, value2, "requestNo");
            return (Criteria) this;
        }

        public Criteria andBankCodeIsNull() {
            addCriterion("bank_code is null");
            return (Criteria) this;
        }

        public Criteria andBankCodeIsNotNull() {
            addCriterion("bank_code is not null");
            return (Criteria) this;
        }

        public Criteria andBankCodeEqualTo(String value) {
            addCriterion("bank_code =", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotEqualTo(String value) {
            addCriterion("bank_code <>", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeGreaterThan(String value) {
            addCriterion("bank_code >", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeGreaterThanOrEqualTo(String value) {
            addCriterion("bank_code >=", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLessThan(String value) {
            addCriterion("bank_code <", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLessThanOrEqualTo(String value) {
            addCriterion("bank_code <=", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeLike(String value) {
            addCriterion("bank_code like", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotLike(String value) {
            addCriterion("bank_code not like", value, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeIn(List<String> values) {
            addCriterion("bank_code in", values, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotIn(List<String> values) {
            addCriterion("bank_code not in", values, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeBetween(String value1, String value2) {
            addCriterion("bank_code between", value1, value2, "bankCode");
            return (Criteria) this;
        }

        public Criteria andBankCodeNotBetween(String value1, String value2) {
            addCriterion("bank_code not between", value1, value2, "bankCode");
            return (Criteria) this;
        }

        public Criteria andRequestTypeIsNull() {
            addCriterion("request_type is null");
            return (Criteria) this;
        }

        public Criteria andRequestTypeIsNotNull() {
            addCriterion("request_type is not null");
            return (Criteria) this;
        }

        public Criteria andRequestTypeEqualTo(String value) {
            addCriterion("request_type =", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeNotEqualTo(String value) {
            addCriterion("request_type <>", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeGreaterThan(String value) {
            addCriterion("request_type >", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeGreaterThanOrEqualTo(String value) {
            addCriterion("request_type >=", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeLessThan(String value) {
            addCriterion("request_type <", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeLessThanOrEqualTo(String value) {
            addCriterion("request_type <=", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeLike(String value) {
            addCriterion("request_type like", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeNotLike(String value) {
            addCriterion("request_type not like", value, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeIn(List<String> values) {
            addCriterion("request_type in", values, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeNotIn(List<String> values) {
            addCriterion("request_type not in", values, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeBetween(String value1, String value2) {
            addCriterion("request_type between", value1, value2, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTypeNotBetween(String value1, String value2) {
            addCriterion("request_type not between", value1, value2, "requestType");
            return (Criteria) this;
        }

        public Criteria andRequestTimeIsNull() {
            addCriterion("request_time is null");
            return (Criteria) this;
        }

        public Criteria andRequestTimeIsNotNull() {
            addCriterion("request_time is not null");
            return (Criteria) this;
        }

        public Criteria andRequestTimeEqualTo(String value) {
            addCriterion("request_time =", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeNotEqualTo(String value) {
            addCriterion("request_time <>", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeGreaterThan(String value) {
            addCriterion("request_time >", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeGreaterThanOrEqualTo(String value) {
            addCriterion("request_time >=", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeLessThan(String value) {
            addCriterion("request_time <", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeLessThanOrEqualTo(String value) {
            addCriterion("request_time <=", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeLike(String value) {
            addCriterion("request_time like", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeNotLike(String value) {
            addCriterion("request_time not like", value, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeIn(List<String> values) {
            addCriterion("request_time in", values, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeNotIn(List<String> values) {
            addCriterion("request_time not in", values, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeBetween(String value1, String value2) {
            addCriterion("request_time between", value1, value2, "requestTime");
            return (Criteria) this;
        }

        public Criteria andRequestTimeNotBetween(String value1, String value2) {
            addCriterion("request_time not between", value1, value2, "requestTime");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoIsNull() {
            addCriterion("bank_request_no is null");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoIsNotNull() {
            addCriterion("bank_request_no is not null");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoEqualTo(String value) {
            addCriterion("bank_request_no =", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoNotEqualTo(String value) {
            addCriterion("bank_request_no <>", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoGreaterThan(String value) {
            addCriterion("bank_request_no >", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoGreaterThanOrEqualTo(String value) {
            addCriterion("bank_request_no >=", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoLessThan(String value) {
            addCriterion("bank_request_no <", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoLessThanOrEqualTo(String value) {
            addCriterion("bank_request_no <=", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoLike(String value) {
            addCriterion("bank_request_no like", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoNotLike(String value) {
            addCriterion("bank_request_no not like", value, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoIn(List<String> values) {
            addCriterion("bank_request_no in", values, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoNotIn(List<String> values) {
            addCriterion("bank_request_no not in", values, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoBetween(String value1, String value2) {
            addCriterion("bank_request_no between", value1, value2, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andBankRequestNoNotBetween(String value1, String value2) {
            addCriterion("bank_request_no not between", value1, value2, "bankRequestNo");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateIsNull() {
            addCriterion("emergency_state is null");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateIsNotNull() {
            addCriterion("emergency_state is not null");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateEqualTo(String value) {
            addCriterion("emergency_state =", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateNotEqualTo(String value) {
            addCriterion("emergency_state <>", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateGreaterThan(String value) {
            addCriterion("emergency_state >", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateGreaterThanOrEqualTo(String value) {
            addCriterion("emergency_state >=", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateLessThan(String value) {
            addCriterion("emergency_state <", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateLessThanOrEqualTo(String value) {
            addCriterion("emergency_state <=", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateLike(String value) {
            addCriterion("emergency_state like", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateNotLike(String value) {
            addCriterion("emergency_state not like", value, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateIn(List<String> values) {
            addCriterion("emergency_state in", values, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateNotIn(List<String> values) {
            addCriterion("emergency_state not in", values, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateBetween(String value1, String value2) {
            addCriterion("emergency_state between", value1, value2, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andEmergencyStateNotBetween(String value1, String value2) {
            addCriterion("emergency_state not between", value1, value2, "emergencyState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateIsNull() {
            addCriterion("intercept_state is null");
            return (Criteria) this;
        }

        public Criteria andInterceptStateIsNotNull() {
            addCriterion("intercept_state is not null");
            return (Criteria) this;
        }

        public Criteria andInterceptStateEqualTo(String value) {
            addCriterion("intercept_state =", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateNotEqualTo(String value) {
            addCriterion("intercept_state <>", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateGreaterThan(String value) {
            addCriterion("intercept_state >", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateGreaterThanOrEqualTo(String value) {
            addCriterion("intercept_state >=", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateLessThan(String value) {
            addCriterion("intercept_state <", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateLessThanOrEqualTo(String value) {
            addCriterion("intercept_state <=", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateLike(String value) {
            addCriterion("intercept_state like", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateNotLike(String value) {
            addCriterion("intercept_state not like", value, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateIn(List<String> values) {
            addCriterion("intercept_state in", values, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateNotIn(List<String> values) {
            addCriterion("intercept_state not in", values, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateBetween(String value1, String value2) {
            addCriterion("intercept_state between", value1, value2, "interceptState");
            return (Criteria) this;
        }

        public Criteria andInterceptStateNotBetween(String value1, String value2) {
            addCriterion("intercept_state not between", value1, value2, "interceptState");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeIsNull() {
            addCriterion("bank_request_type is null");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeIsNotNull() {
            addCriterion("bank_request_type is not null");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeEqualTo(String value) {
            addCriterion("bank_request_type =", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeNotEqualTo(String value) {
            addCriterion("bank_request_type <>", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeGreaterThan(String value) {
            addCriterion("bank_request_type >", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeGreaterThanOrEqualTo(String value) {
            addCriterion("bank_request_type >=", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeLessThan(String value) {
            addCriterion("bank_request_type <", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeLessThanOrEqualTo(String value) {
            addCriterion("bank_request_type <=", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeLike(String value) {
            addCriterion("bank_request_type like", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeNotLike(String value) {
            addCriterion("bank_request_type not like", value, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeIn(List<String> values) {
            addCriterion("bank_request_type in", values, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeNotIn(List<String> values) {
            addCriterion("bank_request_type not in", values, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeBetween(String value1, String value2) {
            addCriterion("bank_request_type between", value1, value2, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andBankRequestTypeNotBetween(String value1, String value2) {
            addCriterion("bank_request_type not between", value1, value2, "bankRequestType");
            return (Criteria) this;
        }

        public Criteria andTradeDateIsNull() {
            addCriterion("trade_date is null");
            return (Criteria) this;
        }

        public Criteria andTradeDateIsNotNull() {
            addCriterion("trade_date is not null");
            return (Criteria) this;
        }

        public Criteria andTradeDateEqualTo(Date value) {
            addCriterion("trade_date =", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotEqualTo(Date value) {
            addCriterion("trade_date <>", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateGreaterThan(Date value) {
            addCriterion("trade_date >", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateGreaterThanOrEqualTo(Date value) {
            addCriterion("trade_date >=", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLessThan(Date value) {
            addCriterion("trade_date <", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLessThanOrEqualTo(Date value) {
            addCriterion("trade_date <=", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateIn(List<Date> values) {
            addCriterion("trade_date in", values, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotIn(List<Date> values) {
            addCriterion("trade_date not in", values, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateBetween(Date value1, Date value2) {
            addCriterion("trade_date between", value1, value2, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotBetween(Date value1, Date value2) {
            addCriterion("trade_date not between", value1, value2, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyIsNull() {
            addCriterion("trade_money is null");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyIsNotNull() {
            addCriterion("trade_money is not null");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyEqualTo(BigDecimal value) {
            addCriterion("trade_money =", value, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyNotEqualTo(BigDecimal value) {
            addCriterion("trade_money <>", value, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyGreaterThan(BigDecimal value) {
            addCriterion("trade_money >", value, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("trade_money >=", value, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyLessThan(BigDecimal value) {
            addCriterion("trade_money <", value, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("trade_money <=", value, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyIn(List<BigDecimal> values) {
            addCriterion("trade_money in", values, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyNotIn(List<BigDecimal> values) {
            addCriterion("trade_money not in", values, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("trade_money between", value1, value2, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andTradeMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("trade_money not between", value1, value2, "tradeMoney");
            return (Criteria) this;
        }

        public Criteria andRealNameIsNull() {
            addCriterion("real_name is null");
            return (Criteria) this;
        }

        public Criteria andRealNameIsNotNull() {
            addCriterion("real_name is not null");
            return (Criteria) this;
        }

        public Criteria andRealNameEqualTo(String value) {
            addCriterion("real_name =", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotEqualTo(String value) {
            addCriterion("real_name <>", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameGreaterThan(String value) {
            addCriterion("real_name >", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameGreaterThanOrEqualTo(String value) {
            addCriterion("real_name >=", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLessThan(String value) {
            addCriterion("real_name <", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLessThanOrEqualTo(String value) {
            addCriterion("real_name <=", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLike(String value) {
            addCriterion("real_name like", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotLike(String value) {
            addCriterion("real_name not like", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameIn(List<String> values) {
            addCriterion("real_name in", values, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotIn(List<String> values) {
            addCriterion("real_name not in", values, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameBetween(String value1, String value2) {
            addCriterion("real_name between", value1, value2, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotBetween(String value1, String value2) {
            addCriterion("real_name not between", value1, value2, "realName");
            return (Criteria) this;
        }

        public Criteria andCertnoIsNull() {
            addCriterion("certno is null");
            return (Criteria) this;
        }

        public Criteria andCertnoIsNotNull() {
            addCriterion("certno is not null");
            return (Criteria) this;
        }

        public Criteria andCertnoEqualTo(String value) {
            addCriterion("certno =", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoNotEqualTo(String value) {
            addCriterion("certno <>", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoGreaterThan(String value) {
            addCriterion("certno >", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoGreaterThanOrEqualTo(String value) {
            addCriterion("certno >=", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoLessThan(String value) {
            addCriterion("certno <", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoLessThanOrEqualTo(String value) {
            addCriterion("certno <=", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoLike(String value) {
            addCriterion("certno like", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoNotLike(String value) {
            addCriterion("certno not like", value, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoIn(List<String> values) {
            addCriterion("certno in", values, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoNotIn(List<String> values) {
            addCriterion("certno not in", values, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoBetween(String value1, String value2) {
            addCriterion("certno between", value1, value2, "certno");
            return (Criteria) this;
        }

        public Criteria andCertnoNotBetween(String value1, String value2) {
            addCriterion("certno not between", value1, value2, "certno");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNull() {
            addCriterion("telephone is null");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNotNull() {
            addCriterion("telephone is not null");
            return (Criteria) this;
        }

        public Criteria andTelephoneEqualTo(String value) {
            addCriterion("telephone =", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotEqualTo(String value) {
            addCriterion("telephone <>", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThan(String value) {
            addCriterion("telephone >", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("telephone >=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThan(String value) {
            addCriterion("telephone <", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThanOrEqualTo(String value) {
            addCriterion("telephone <=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLike(String value) {
            addCriterion("telephone like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotLike(String value) {
            addCriterion("telephone not like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneIn(List<String> values) {
            addCriterion("telephone in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotIn(List<String> values) {
            addCriterion("telephone not in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneBetween(String value1, String value2) {
            addCriterion("telephone between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotBetween(String value1, String value2) {
            addCriterion("telephone not between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountIsNull() {
            addCriterion("jd_attach_count is null");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountIsNotNull() {
            addCriterion("jd_attach_count is not null");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountEqualTo(Integer value) {
            addCriterion("jd_attach_count =", value, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountNotEqualTo(Integer value) {
            addCriterion("jd_attach_count <>", value, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountGreaterThan(Integer value) {
            addCriterion("jd_attach_count >", value, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("jd_attach_count >=", value, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountLessThan(Integer value) {
            addCriterion("jd_attach_count <", value, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountLessThanOrEqualTo(Integer value) {
            addCriterion("jd_attach_count <=", value, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountIn(List<Integer> values) {
            addCriterion("jd_attach_count in", values, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountNotIn(List<Integer> values) {
            addCriterion("jd_attach_count not in", values, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountBetween(Integer value1, Integer value2) {
            addCriterion("jd_attach_count between", value1, value2, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andJdAttachCountNotBetween(Integer value1, Integer value2) {
            addCriterion("jd_attach_count not between", value1, value2, "jdAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountIsNull() {
            addCriterion("bank_attach_count is null");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountIsNotNull() {
            addCriterion("bank_attach_count is not null");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountEqualTo(Integer value) {
            addCriterion("bank_attach_count =", value, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountNotEqualTo(Integer value) {
            addCriterion("bank_attach_count <>", value, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountGreaterThan(Integer value) {
            addCriterion("bank_attach_count >", value, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("bank_attach_count >=", value, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountLessThan(Integer value) {
            addCriterion("bank_attach_count <", value, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountLessThanOrEqualTo(Integer value) {
            addCriterion("bank_attach_count <=", value, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountIn(List<Integer> values) {
            addCriterion("bank_attach_count in", values, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountNotIn(List<Integer> values) {
            addCriterion("bank_attach_count not in", values, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountBetween(Integer value1, Integer value2) {
            addCriterion("bank_attach_count between", value1, value2, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachCountNotBetween(Integer value1, Integer value2) {
            addCriterion("bank_attach_count not between", value1, value2, "bankAttachCount");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileIsNull() {
            addCriterion("bank_attach_file is null");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileIsNotNull() {
            addCriterion("bank_attach_file is not null");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileEqualTo(String value) {
            addCriterion("bank_attach_file =", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileNotEqualTo(String value) {
            addCriterion("bank_attach_file <>", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileGreaterThan(String value) {
            addCriterion("bank_attach_file >", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileGreaterThanOrEqualTo(String value) {
            addCriterion("bank_attach_file >=", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileLessThan(String value) {
            addCriterion("bank_attach_file <", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileLessThanOrEqualTo(String value) {
            addCriterion("bank_attach_file <=", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileLike(String value) {
            addCriterion("bank_attach_file like", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileNotLike(String value) {
            addCriterion("bank_attach_file not like", value, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileIn(List<String> values) {
            addCriterion("bank_attach_file in", values, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileNotIn(List<String> values) {
            addCriterion("bank_attach_file not in", values, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileBetween(String value1, String value2) {
            addCriterion("bank_attach_file between", value1, value2, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankAttachFileNotBetween(String value1, String value2) {
            addCriterion("bank_attach_file not between", value1, value2, "bankAttachFile");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateIsNull() {
            addCriterion("bank_request_state is null");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateIsNotNull() {
            addCriterion("bank_request_state is not null");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateEqualTo(String value) {
            addCriterion("bank_request_state =", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateNotEqualTo(String value) {
            addCriterion("bank_request_state <>", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateGreaterThan(String value) {
            addCriterion("bank_request_state >", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateGreaterThanOrEqualTo(String value) {
            addCriterion("bank_request_state >=", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateLessThan(String value) {
            addCriterion("bank_request_state <", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateLessThanOrEqualTo(String value) {
            addCriterion("bank_request_state <=", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateLike(String value) {
            addCriterion("bank_request_state like", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateNotLike(String value) {
            addCriterion("bank_request_state not like", value, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateIn(List<String> values) {
            addCriterion("bank_request_state in", values, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateNotIn(List<String> values) {
            addCriterion("bank_request_state not in", values, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateBetween(String value1, String value2) {
            addCriterion("bank_request_state between", value1, value2, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andBankRequestStateNotBetween(String value1, String value2) {
            addCriterion("bank_request_state not between", value1, value2, "bankRequestState");
            return (Criteria) this;
        }

        public Criteria andSendTimeIsNull() {
            addCriterion("send_time is null");
            return (Criteria) this;
        }

        public Criteria andSendTimeIsNotNull() {
            addCriterion("send_time is not null");
            return (Criteria) this;
        }

        public Criteria andSendTimeEqualTo(Date value) {
            addCriterion("send_time =", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeNotEqualTo(Date value) {
            addCriterion("send_time <>", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeGreaterThan(Date value) {
            addCriterion("send_time >", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("send_time >=", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeLessThan(Date value) {
            addCriterion("send_time <", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeLessThanOrEqualTo(Date value) {
            addCriterion("send_time <=", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeIn(List<Date> values) {
            addCriterion("send_time in", values, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeNotIn(List<Date> values) {
            addCriterion("send_time not in", values, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeBetween(Date value1, Date value2) {
            addCriterion("send_time between", value1, value2, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeNotBetween(Date value1, Date value2) {
            addCriterion("send_time not between", value1, value2, "sendTime");
            return (Criteria) this;
        }

        public Criteria andCreatedDateIsNull() {
            addCriterion("created_date is null");
            return (Criteria) this;
        }

        public Criteria andCreatedDateIsNotNull() {
            addCriterion("created_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedDateEqualTo(Date value) {
            addCriterion("created_date =", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateNotEqualTo(Date value) {
            addCriterion("created_date <>", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateGreaterThan(Date value) {
            addCriterion("created_date >", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("created_date >=", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateLessThan(Date value) {
            addCriterion("created_date <", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateLessThanOrEqualTo(Date value) {
            addCriterion("created_date <=", value, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateIn(List<Date> values) {
            addCriterion("created_date in", values, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateNotIn(List<Date> values) {
            addCriterion("created_date not in", values, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateBetween(Date value1, Date value2) {
            addCriterion("created_date between", value1, value2, "createdDate");
            return (Criteria) this;
        }

        public Criteria andCreatedDateNotBetween(Date value1, Date value2) {
            addCriterion("created_date not between", value1, value2, "createdDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateIsNull() {
            addCriterion("modified_date is null");
            return (Criteria) this;
        }

        public Criteria andModifiedDateIsNotNull() {
            addCriterion("modified_date is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedDateEqualTo(Date value) {
            addCriterion("modified_date =", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateNotEqualTo(Date value) {
            addCriterion("modified_date <>", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateGreaterThan(Date value) {
            addCriterion("modified_date >", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("modified_date >=", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateLessThan(Date value) {
            addCriterion("modified_date <", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateLessThanOrEqualTo(Date value) {
            addCriterion("modified_date <=", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateIn(List<Date> values) {
            addCriterion("modified_date in", values, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateNotIn(List<Date> values) {
            addCriterion("modified_date not in", values, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateBetween(Date value1, Date value2) {
            addCriterion("modified_date between", value1, value2, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateNotBetween(Date value1, Date value2) {
            addCriterion("modified_date not between", value1, value2, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}